SyStudentNI

Logical Entity Name | SyStudentNI
Default Table Name | SyStudentNI
Physical Only | NO
Owner | dbo
Definition |
Note |

SyStudentNI Columns

ColumnName | Domain | Datatype | NULL | Definition
SyStudentID |  | int | NO |
AdEnrollID |  | int | YES |
DSOSyStaffID |  | int | YES |
SyVisaCode |  | char(8) | YES |
SEVISID |  | varchar(11) | YES |
ProgStartDate |  | datetime | YES |
ProgEndDate |  | datetime | YES |
COA |  | money | NO |
TransStatus |  | char(1) | YES |
EnrollStatus |  | char(1) | YES |
TaxID |  | char(9) | YES |
CountryOfBirth |  | char(2) | YES |
CountryOfLPR |  | char(2) | YES |
CountryOfCitizenship |  | char(2) | YES |
TerminateReason |  | char(6) | YES |
Remarks |  | varchar(250) | YES |
ProgRemarks |  | varchar(250) | YES |
FormNumber |  | varchar(30) | YES |
EduLevel |  | char(2) | YES |
Major |  | char(7) | YES |
Minor |  | char(7) | YES |
ProofOfHealth |  | bit | NO |
HealthProvider |  | varchar(60) | YES |
HealthEndDate |  | datetime | YES |
InsuranceCost |  | money | NO |
FormPurpose |  | char(1) | YES |
TransferFrom |  | varchar(100) | YES |
Position |  | char(3) | YES |
EngProfRequired |  | bit | NO |
EngProfMet |  | bit | NO |
NoEPReqReason |  | varchar(500) | YES |
SchoolFund |  | money | NO |
SchoolFundDescription |  | varchar(60) | YES |
OtherFund |  | money | NO |
OtherFundDescrip |  | varchar(60) | YES |
Employment |  | money | NO |
EmploymentDescrip |  | varchar(60) | YES |
UsGovtAg1 |  | char(6) | YES |
UsGovtAg2 |  | char(6) | YES |
UsGovtAgFund1 |  | money | NO |
UsGovtAgFund2 |  | money | NO |
UsIntlAg1 |  | char(6) | YES |
UsIntlAg2 |  | char(6) | YES |
UsIntlAgFund1 |  | money | NO |
UsIntlAgFund2 |  | money | NO |
Personalfund |  | money | NO |
BiNatCommFund |  | money | NO |
NonImGvmtFund |  | money | NO |
FundRemarks |  | varchar(250) | YES |
PassportNum |  | varchar(40) | YES |
PassportCountry |  | char(2) | YES |
PassportExp |  | datetime | YES |
VisaNum |  | varchar(40) | YES |
VisaDate |  | datetime | YES |
VisaPost |  | varchar(50) | YES |
VisaExp |  | datetime | YES |
I94 |  | varchar(40) | YES |
I94Exp |  | datetime | YES |
I94DS |  | bit | NO |
PortOfEntry |  | varchar(50) | YES |
DateofEntry |  | datetime | YES |
Comments |  | varchar(2000) | YES |
OffCampusPrintReq |  | bit | NO |
OffCampusEmploymentType |  | char(2) | YES |
OffCampusRecommendation |  | varchar(250) | YES |
CPTPrintReq |  | bit | NO |
CPTApplicationDate |  | datetime | YES |
CPTApprovalDate |  | datetime | YES |
CPTEmploymentStartDate |  | datetime | YES |
CPTEmploymentEndDate |  | datetime | YES |
CPTEmployerID |  | int | YES |
CPTCourseRelevance |  | varchar(200) | YES |
OPTPrintReq |  | bit | NO |
OPTApplicationDate |  | datetime | YES |
OPTApprovalDate |  | datetime | YES |
OPTEmploymentStartDate |  | datetime | YES |
OPTEmploymentEndDate |  | datetime | YES |
OPTEmployerID |  | int | YES |
OPTCourseRelevance |  | varchar(200) | YES |
AuthReason |  | char(2) | YES |
AuthStartDate |  | datetime | YES |
AuthEndDate |  | datetime | YES |
DBFRemarks |  | nvarchar(1000) | YES |
DateAdded |  | datetime | NO |
DateLstMod |  | datetime | NO |
UserID |  | int | NO |
Ts |  | timestamp | NO |
LivingExpense |  | money | NO |
OtherExpense |  | money | NO |
OtherExpenseDescrip |  | varchar(60) | YES |
Category |  | char(3) | YES |
SessionStartDate |  | datetime | YES |
SessionEndDate |  | datetime | YES |
Commuter |  | bit | NO |
CriminalConviction |  | bit | NO |
EVMatriculation |  | char(2) | YES |
InfractionType |  | char(3) | YES |
BirthCity |  | varchar(100) | YES |
CRMSuppressFlag |  | bit | NO |
SyStudentNIID |  | int | NO |
Major2 |  | char(7) | YES |
OffCampusRemarks |  | nvarchar(1000) | YES |
IsDisciplineDueToCrime |  | bit | YES |

SyStudentNI Primary and Unique Keys

Key Name | Key Type | Keys
SyStudentNI_SyStudentID_U_C_IDX | Index | SyStudentID
PK_SyStudentNI | PrimaryKey | SyStudentNIID

SyStudentNI Foreign Keys

Parent Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Not For Replication
AdEnroll | Non-Identifying | Zero or One to Zero or More | FK_SyStudentNI_AdEnrollID_AdEnroll_AdEnrollID |  |  | AdEnrollID | NO | YES
SySEVISCountry | Non-Identifying | Zero or One to Zero or More | FK_SyStudentNI_CountryOfBirth_SySEVISCountry_Code |  |  | CountryOfBirth | NO | YES
SySEVISCountry | Non-Identifying | Zero or One to Zero or More | FK_SyStudentNI_CountryOfCitizenship_SySEVISCountry_Code |  |  | CountryOfCitizenship | NO | YES
SySEVISCountry | Non-Identifying | Zero or One to Zero or More | FK_SyStudentNI_CountryOfLPR_SySEVISCountry_Code |  |  | CountryOfLPR | NO | YES
PlEmployer | Non-Identifying | Zero or One to Zero or More | FK_SyStudentNI_CPTEmployerID_PlEmployer_PlEmployerID |  |  | CPTEmployerID | NO | YES
SyStaff | Non-Identifying | Zero or One to Zero or More | FK_SyStudentNI_DSOSyStaffID_SyStaff_SyStaffID |  |  | DSOSyStaffID | NO | YES
PlEmployer | Non-Identifying | Zero or One to Zero or More | FK_SyStudentNI_OPTEmployerID_PlEmployer_PlEmployerID |  |  | OPTEmployerID | NO | YES
SySEVISPosition | Non-Identifying | Zero or One to Zero or More | FK_SyStudentNI_Position_SySEVISPosition_Code |  |  | Position | NO | YES
syStudent | Non-Identifying | One To Zero or More | FK_SyStudentNI_SyStudentID_syStudent_SyStudentID |  |  | SyStudentID | NO | YES
SyVisa | Non-Identifying | Zero or One to Zero or More | FK_SyStudentNI_SyVisaCode_SyVisa_Code |  |  | SyVisaCode | NO | YES
SyStaff | Non-Identifying | One To Zero or More | FK_SyStudentNI_UserID_SyStaff_SyStaffID |  |  | UserID | NO | YES

Child Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Not For Replication

SyStudentNI Check Constraints

Check Constraint Name | CheckConstraint
Chk_SyStudentNI_USIntlAgFund1 | ([UsIntlAg1] is not null or [UsIntlAgFund1] = 0)
Chk_SyStudentNI_UsGovtAgFund2 | ([UsGovtAg2] is not null or [UsGovtAgFund2] = 0)
Chk_SyStudentNI_USGovtAgFund1 | ([UsGovtAg1] is not null or [UsGovtAgFund1] = 0)
Chk_SyStudentNI_AuthStartDate | ([AuthStartDate] <= [AuthEndDate])
Chk_SyStudentNI_OPTEmploymentStartDate | ([OPTEmploymentStartDate] <= [OPTEmploymentEndDate])
Chk_SyStudentNI_OPTApplicationDate | ([OPTApplicationDate] <= [OPTApprovalDate])
Chk_SyStudentNI_CPTEmploymentStartDate | ([CPTEmploymentStartDate] <= [CPTEmploymentEndDate])
Chk_SyStudentNI_CPTApplicationDate | ([CPTApplicationDate] <= [CPTApprovalDate])
Chk_SyStudentNI_ProgStartDate | ([ProgStartDate] <= [ProgEndDate])
Chk_SyStudentNI_EngProfRequired_EngProfMet | ([EngProfRequired] = 1 and [EngProfMet] = 0 or [EngProfRequired] = 1 and [EngProfMet] = 1 or [EngProfRequired] = 0 and [EngProfMet] = 0)
Chk_SyStudentNI_UsIntlAgFund2 | ([UsIntlAg2] is not null or [UsIntlAgFund2] = 0)

SyStudentNI Storage

STORAGE OPTION | STORAGE VALUE
Filegroup | C2000_Index
Text Image File Group |

SyStudentNI Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.SevisStudent | NO |  |  |
Physical (Microsoft SQL Server) dbo.SyStudentNI | NO |  |  |

SyStudentNI Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Logical | SEVIS
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | System

SyStudentNI Data Movement Rules

Name | Type | Rule Text/Value